The SQL Server Dba’s Guide to Docker Containers: Agile Deployment Without Infrastructure Lock-in

Table of Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Chapter 1: Introduction to Containers
	The Latest 30-Year-Old Technology
	Docker – The Company and the Container Runtime
	The Case for Containers
	Containers vs. Virtualization
	Microsoft, Containers, and SQL Server on Linux
	Summary
Chapter 2: Install and Configure Docker on Windows Server
	Minimum System Requirements
	Enable Containers Feature in Windows Server 2016
	Download and Install the Docker-Microsoft PackageManagement Provider
	Download and Install the Docker Package
	Verifying the Docker Engine Installation
	Docker Desktop for Windows
	Summary
Chapter 3: Install and Configure Docker on Linux
	Minimum System Requirements
	Basic Linux Commands You Need to Get Started
	Installing Docker on CentOS Linux
		Update the CentOS System Packages
		Install the Required Dependencies
		Add the Docker Stable Repository to Your System
		Install Docker CE
		Starting the Docker Daemon and Enabling on Startup
	Installing Docker on Ubuntu Linux
		Update the Ubuntu System Packages
		Install the Required Dependencies for Connecting to a Repository over HTTPS
		Add the Official GPG Key from Docker
		Add the Docker Stable Repository to Your System
		Install Docker CE
	Verifying the Docker Engine Installation
	Getting Rid of sudo?
	Summary
Chapter 4: The Docker Ecosystem
	Hello World: Docker Edition
	How Docker Runs Containers
	The Docker Ecosystem
		Docker CLI
	Docker Daemon
	Docker Commands
	Docker Images and Containers
	Docker Hub
	Exploring Docker Hub
	Docker Image Naming Conventions
	Running SQL Server on Windows Containers
	Running SQL Server on Linux Containers
	Beginning to Explore Containers and Images
	Things to Consider
	Connecting to the SQL Server Instance Remotely
	Lifecycle of a Container
	Summary
Chapter 5: Docker Images and Containers
	A Quick Review (And Then Some…)
	Behind the Scenes of Pulling Images
		Fat Manifest?
		Image Manifest
		Content Digest
		Distribution Hash
	Your Docker Host’s Local Filesystem
		Union Filesystem
		Files, Directory Names, and Symbolic Links
	Stitching Layers: Assembling the Image
		How a Union FileSystem Works
		Traversing the Layers
	The Container Layer
	Summary
Chapter 6: Managing and Administering Containers
	Configuring the Docker Daemon
		Working with dockerd
		Working with daemon.json
		Changing the Default Image and Container Directory
	Stopping and Restarting the Docker Daemon
	Configure the Docker Daemon for Remote Access on CentOS Linux
		Configure Remote Access to the Docker Daemon with the systemd Unit File
		Protect the Docker Daemon Socket by Configuring Mutual TLS Encryption
		Update the daemon.json to Include the Settings for Mutual TLS Encryption
		Enable Firewall Port to Allow Traffic to Docker Daemon
		Testing Remote Client Connectivity
		Cleanup
	Configure Docker CLI Bash Completion
	Starting and Stopping Containers
	Deleting Containers and Images
	Interacting with Running Containers
	Sharing Files Between Host and Container
	Configuring Container Resources
	Exploring the Container Logs
	Reviewing the Status of the Docker Daemon
	Summary
Chapter 7: Persisting Data
	Stateful vs. Stateless Applications
	Containers Are Ephemeral and Immutable
	How Cloud Providers Implement Infrastructure- as-a-Service
	Docker Volumes
	Attach Volumes to Containers
		To -v or to --mount
		Sharing Volumes Between Containers?
	Leveraging Volumes with SQL Server on Containers
	Smart SQL Server In-Place Upgrade
	Summary
Chapter 8: Working with SQL Server on Linux
	SQL Server on Linux Architecture
		Project Drawbridge
		SQLOS and SQLPAL
	Difference Between SQL Server on Windows vs. Linux
	Installing SQL Server on Linux
		Manual Installation
		Unattended Installation
	Configuring the Firewall
	A Note on the Linux Firewalls and Docker
	Configuring SQL Server on Linux
		Enabling the SQL Server Agent
		Configuring Default Database Data and Log Directory
		Configuring Default Database Backup Directory
		Enabling Trace Flags
		Viewing All Instance-Level Configuration Settings
	Working with the Filesystem
	Important Directories in the Linux Filesystem
	File Permissions
	Assigning Permissions to Files and Directories
	Writing a Simple Linux Bash Script
		Running the Script
		Passing Parameters to the Script
		Adding Conditional Logic in Bash Scripts
	Summary
Chapter 9: Creating Custom SQL Server on Windows Container Images
	Creating Custom Docker Images
	Exploring the Dockerfile
		The File
		The FROM Instruction
		The LABEL Instruction
		The RUN Instruction
		The COPY Instruction
		The ADD Instruction
		The SHELL Instruction
		The CMD Instruction
	The ENTRYPOINT Instruction
	CMD vs. RUN vs. SHELL vs. ENTRYPOINT
	The WORKDIR Instruction
	The ENV Instruction
	Using Escape Characters
	Putting the Pieces Together with a Dockerfile
	Build the Custom SQL Server on Windows Image
	Optimizing the Dockerfile
	Summary
Chapter 10: Creating Custom SQL Server on Linux Container Images
	Additional Dockerfile Instructions
		The EXPOSE Instruction
		The VOLUME Instruction
		The USER Instruction
	Build the Custom SQL Server on Linux Image
		Installing a Specific SQL Server Version
		Creating a Custom Image That Runs As Non-root
		Running a Container As Non-root
	Non-root User and Docker Volumes
	Optimizing the Dockerfile
	Running Scripts Inside the Dockerfile
		Install the SQL Server Command-Line Utilities
		Write the Bash Script to Check for Backups
		Run the Bash Script in the Last Instruction
	Multi-stage Builds
	Docker Compose and YAML Files
		Installing Docker Compose
		Creating a YAML File for Multi-container Apps
	Summary
Chapter 11: Guide to Docker Networking for SQL Server DBAs
	The docker0 Bridge
	Virtual Network Adapters
	Working with and Exposing Ports: Running Multiple SQL Server Instances on Linux via Containers
	Using the Same Port on Multiple Containers
	Intra-container Communications
	Putting It All Together
	Summary
Appendix A: Building a Personal Lab Environment
	The Need for a Personal Lab
	Software for the Lab Environment
	Operating System
	Virtualization Platform
	Installing CentOS Linux Server
	Installing Ubuntu Linux Server
	Utilizing Public Cloud Resources
		Provisioning a Linux Docker Host on Microsoft Azure
		Provisioning a Linux Docker Host on AWS
		Provisioning a Linux Docker Host on Google Cloud Platform
	Linux Client Tools
		Using SSH to Connect to Linux
		Using WinSCP for Copying Files to Linux
	SQL Server Client Tools
		Azure Data Studio
		mssql-cli
	Summary
Index